
<%@page import="classes.Reports"%>
<%@page import="java.util.ArrayList"%>
<script type="text/javascript">
       function change(str){
      $("#main-content").load(str);
       }
</script>
<%
    String query="SELECT * FROM brchung.client C, brchung.person P WHERE C.Id=P.SSN and P.role='c';";
    Reports.getConnection(query);
            ArrayList<String[]> rs=Reports.getResults(7,6,13,5);
            for(int i=0;i<rs.size();i++){
                out.print("<a onclick=\"change('CustomerRep/stocksuggest.jsp?id="+rs.get(i)[3] +"')\" >");
                out.print(rs.get(i)[0]+" "+rs.get(i)[1]+" (id:"+rs.get(i)[2]+")");
                out.print("<br/></a>");
            }
%>

